Introduction to Database management system (DBMS)
Database management system is a collection of interrelated data and a set of programs to access those data. The collection of data, usually referred to as the
database, contains information relevant to an enterprises.
The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient.
Uses of Database Management System
Databases touch all aspects of our lives.
* Banking:. All Transactions
* Airlines: Reservations, schedules
* University: Registration, grades
* Sales: Customers, products, purchases
* Manufacturing: Production, inventory, orders, supply chain
* Human resources: Employee records, salaries, tax deductions.
Examples of Data base management software
- Microsoft Access: Access is a personal database system from Microsoft. It is very visually oriented software product, making it easy for non- programmers the develop useful database
- Visual FoxPro: FoxPro is a relational database system, also produced by Microsoft that is tightly coupled to it’s programming language. FoxPro is less friendly as an end-user database, requiring more technical expertise than Access.
- MYSQL Database: This is a server-based database that enables multiple users to access multiple platforms, including most varieties of UNIX and Windows.
- Oracle. The Oracle database is another enterprise-level scalable database. The SQL -based database supports distributed corporate database, enabling the user to access data locally or from remote database in a transparent transaction.
ADVANTAGES OF DBMS
- Day Independence
- Efficient data access
3.Data integrity And security
- Data administration
- Concurrent access and crash recovery
- Reduced application development time
DISADVANTAGES OF DBMS
- Danger of overkill
- Complexity
- Qualified Personal
- Costs
- Lower efficiency
DOWNLOAD DOCUMENT HERE: Computer Database manage-WPS Office